Well I haven’t tried it in Bubble yet, but we talked about it here …
The optimistic lock is probably the one you want.