Right. And this article reminds me of people trying to use a SQL database like a filesystem. "Lock file before update otherwise it will get overwritten".

Don't use record lock as like it's an attribute of a row. Add a column on the table called "status" and use it.