UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'btKUM57ThnIz2JFIKY3U4FzrfDvggvuRneytW8Cuhp4='
WHERE
key_id = '696d6aa043d6f8c9367f79f91d5344f197fce94fe5e9a76a48531c0cd0fc385c'
AND (
token = 'btKUM57ThnIz2JFIKY3U4FzrfDvggvuRneytW8Cuhp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)