View principle of operation update.
The record is locked, then update is performed and then you can only work with this record. In principle, because of this, some articles on optimizing and reducing load on the server, it is recommended not to use often update