Mysql - Rows not updated in transactions without any errors
MyISAM ignores all transaction semantics.  Convert to InnoDB !

But maybe that does not answer the Question.  The one MyISAM table seems to be merely an audit log.

Further head scratching....

Please provide the transaction log for the bad case.