`pessimistic_lock` can be cached

[ekexium]

Currently pessimistic_lock will always issue a request. If heartbeat is enabled, we don't have to lock the same key for multiple times. For get_for_update-like operations, we can have a separate cache to cache its value.