feat: lock-base transaction implementation

[mrekucci]

Checklist

• [x] I have read the coding guide
• [ ] My change requires a documentation update and I have done it
• [ ] I have added tests to cover my changes.
• [x] I have filled out the description and linked the related issues

Description

A simple lock-base transaction implementation. Closes #3195 #3204

---

This change is