my few c
1. select for update to lock selects, then update the btc value, in a transaction.
There are many others like hashing and triggers to validate data, and to ensure sql injection if happens can be discovered easily.
Update set new value=old value - difference is more efficient and locks the row with resorting to the lock you mention. Add a check constraint on table.