UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9e/P4CnlmuAjxJRFq4TNKZwVXrUj3RiBy96ugBlPUv0='
WHERE
key_id = '06cb713ed96e8739c37761158f66f381882d034f668ff3f50746af0a88b1f05c'
AND (
token = '9e/P4CnlmuAjxJRFq4TNKZwVXrUj3RiBy96ugBlPUv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)