14.2.7.3 SELECT ... FOR UPDATE and SELECT ... - MySQL

For index records the search encounters, SELECT ... FOR UPDATE blocks other sessions from doing SELECT ... LOCK IN SHARE MODE or from reading in ...

dev.mysql.com