Add support for using `GetForUpdate` in `get` method

[kriszyp]

There are situations where we want transactions to fail if the a read record is changed before the commit.