Suppose
Are the table locked during these ten seconds?
No, they would not be locked when you 'spend ten seconds to think', otherwise this would be sort of checking out rows/tables. Of course, this means that some other process could also read and write changes in those ten seconds, which could lead to concurrency issues for you.