Why should both balance updates in a bank transfer be placed in one transaction?
So account rows are automatically sorted alphabetically.
So the debit and credit can be finalized as one all-or-nothing unit.
So MySQL creates a duplicate of every affected account.
So uniqueness and other table constraints are ignored.