I have a case when SF data can be updated concurrently by humans with UI and by a Ruby app via REST API, so I'm worried about the possibility they overwrite changes of each other.
Is there a standard way to conditionally make an update only if the object hasn't been changed in the meanwhile?(check the version of object, or last update time, etc).
Or is it possible to achieve this with a SOQL query similar to this?
update stuff set calculated_field = 'new value' where base_field = 'expected old value'