At least in MySQL, when you run an update statement it implicitly places a write lock on the row, which is released at end of transaction. Other databases are similar.