UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wQJ7IAvMp785HYR52NUeLnmdyohiw3A1Kc3zABZHv7w='
WHERE
key_id = '72cf652439afcf092abceca88cc8242c2a4ecd96792576051227b488332fed8f'
AND (
token = 'wQJ7IAvMp785HYR52NUeLnmdyohiw3A1Kc3zABZHv7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)