Rename condition emacsql-lock to emacsql-locked.
Enhance emacsql-with-transaction to retry.