Optimistic Locking: What Happens When Two Users Update the Same Row?

Let's say you're building a todo app. Nothing complicated. You have a list of todos, and each todo has a title and a checkbox to mark it as completed. Your database looks something like this: CREATE T