UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w509cEX+eoMBgYuPRuXrDuFy1kfM44hcvXKA5tjJNZQ='
WHERE
key_id = 'f797ea1ca916cc2313c6d820280d350696a3e4ce6b0f97b2a0e3461a5e9d247e'
AND (
token = 'w509cEX+eoMBgYuPRuXrDuFy1kfM44hcvXKA5tjJNZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)