been using select for update for many years now, in production. never had any issues. (MariaDB)