I can see that my where params on sql update statements only use the
key fields.

Is it possible to make it use all fields? in order to make it
impossible to overwrite other users updates (optimistic locking).

I would like to avoid using the pesimistic locking scheme that the
components provide, because of the possibbly very long lasting locks.