14.2.5 Locking Reads (SELECT ... FOR UPDATE ... - 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