> But the two ATMs problem would be solved by securing a lock on the database before proceeding with the transaction?

You can also let an overdraft occur. Now the user ows the bank some money and you can charge them interest for their debt.