@mgiambance I don't mean use it as transaction, i want to lock the key while updating, I don't want any request to access the key before update is finished.
Wouldn't a transaction do that? Lock the key until all updates have been completed? I'd assume if it locks it so all the queries could be completed, it'll also lock out all other requests from other clients / servers.