UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9QYPkiLBn0K8ZodlPcUwWC48PrkUEqhhfQMcRofJV8U='
WHERE
key_id = 'b1d51ecf5c82eed6ab9ffe6c6bb5c5e61ea0f3024a36d26eff5d332e1740ea10'
AND (
token = '9QYPkiLBn0K8ZodlPcUwWC48PrkUEqhhfQMcRofJV8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)