UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eHRG3mX9HvYPmWjZ0hBHpEoCIyZIrwziNcILRpVPmE8='
WHERE
key_id = '85c49959c837b87ff690d86f5cca5ad7ccf2229e7593decd809d5a1379af626e'
AND (
token = 'eHRG3mX9HvYPmWjZ0hBHpEoCIyZIrwziNcILRpVPmE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)