What would be a good way to lock a row when performing a SELECT? https://stackoverflow.com/questions/6066205/when-using-mysqls-for-update-locking-what-is-exactly-locked

I couldn't find anything that's even close. If there isn't anything built-in, could this be done easily using an extension?