locks are completely different topic, @Transactional simply not build for locking support. You have to apply either pessimistic locking on your query or Optimistic locking by maintaining a version.

But why not use a distributed locking mechanism? https://redis.io/docs/manual/patterns/distributed-locks/