Update notes for submitted changes

* Added SELECT FOR UPDATE to prevent deadlocks in tests