14.6.3.4 SELECT ... FOR UPDATE and SELECT ... - MySQL

If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection.

dev.mysql.com