UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8jAbe8D9HLK6WwAnWmoDKxwGOk+p4PtbT86JH6srit4='
WHERE
key_id = '861cd26ebbe8af66d48557ad7db30cd99f526ee463969d8fc49a57397ec8b916'
AND (
token = '8jAbe8D9HLK6WwAnWmoDKxwGOk+p4PtbT86JH6srit4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)