UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ir5GEbjVp/CK23JY5KiygeUTpiOLQrtP1Jg2Fm9BSDw='
WHERE
key_id = '95738b95ee17f9c7c668991968edbcddc34c762d4f8c6611f650e0abcd4bd2f6'
AND (
token = 'ir5GEbjVp/CK23JY5KiygeUTpiOLQrtP1Jg2Fm9BSDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)