UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M/PgRFdhNfeiZ8sYjjQgLUaFcN/bB0omFn8WpF7ybHU='
WHERE
key_id = '247f7fc70ae6e3fcae5781588671d3845897c940a67602a9942aa116d04adb82'
AND (
token = 'M/PgRFdhNfeiZ8sYjjQgLUaFcN/bB0omFn8WpF7ybHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)