I have a whitepaper about scalable consistency guarantees using optimistic transactions. It should solve these very problems.

https://medium.com/@andrasgerlits/optimistic-acid-transactio...