Using with_lock_retries outside of an existing transaction scope is safe
because it doesn't require us opening a subtransaction. Hence add
assertions to make sure we're outside of a transaction scope.