背景: updateop_message_shop_user_refomrefleftjoinop_messageomonomref.message_id=om.idsetomref.click_state='1',omref.update_time=now()WHEREomref.fk_shp_user_id=?andomref.click_state='0'andomref.del='0'andom.type=? Cause:com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException:Lockwaittimeoutexc...