Credit accounts id = 1 and id = 2 in accounts by 1 each. So concurrent operations cannot deadlock, change both rows in one statement — then locks are taken in a single consistent order, not by two separate updates in an arbitrary order.