FOR UPDATE Clause

You can use the FOR UPDATE clause to indicate the need to lock the data which you read into transaction.

This data becomes inaccessible for reading in other sessions. For file mode, specified tables are locked, but for client/server mode only selected records are locked. The lock is released after the transaction is completed.