Thanks for the answer. The index 23 is on revision_id and author_user_id in the revision table. There are a few more indexes on this table but not 23....
I thought that the update locks could not be shared. I am wondering how would two threads have an update lock on the same resource ie 7:53575229:23 ?...