UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U8bAnVftpDOZwU9i86qqXZmdlAc4SdD3LqQFsQI8ckQ='
WHERE
key_id = 'e69911ddae98407515dab1f7d110153fb445588ea43e3a14235b7b9a27f6b489'
AND (
token = 'U8bAnVftpDOZwU9i86qqXZmdlAc4SdD3LqQFsQI8ckQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)