UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BYLxOI2WVbHgaEX7tgDvHE3En9pXmanHAHYYVOJF074='
WHERE
key_id = 'b7a62ca39b6dcb629b0b2c3d82cb603670bebb79b3c37b720708aba58e908706'
AND (
token = 'BYLxOI2WVbHgaEX7tgDvHE3En9pXmanHAHYYVOJF074='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)