Multi-version concurrency control

A FOR UPDATE clause moves a SELECT onto InnoDB's write path

InnoDB applies MVCC to reads and pure locking to writes, so under the default Repeatable Read the same predicate can be answered from a snapshot frozen at your first statement or from the newest committed row.