Adding full support for optimistic concurrency in the update pipeline

I wonder if it is really worth doing another read here. How easy would it be for somebody to get into the state where too many rows were returned?