UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VlTArAaC1O9gO4zA4M1yyBqq8LHwKleXkjEyCw6pDQo='
WHERE
key_id = '31f25ce6972f714244a986cd6282eaabc86e426947ca9c905a8f10ce4c72ce22'
AND (
token = 'VlTArAaC1O9gO4zA4M1yyBqq8LHwKleXkjEyCw6pDQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)