UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4M46MbTQkXNCpUSBNjur9yWX0oei28pvsHMMqgYvYVo='
WHERE
key_id = '17ffa665b9230675cc2b55673f5a1929401becc1ec71adc55d85c30a2ef5f8c9'
AND (
token = '4M46MbTQkXNCpUSBNjur9yWX0oei28pvsHMMqgYvYVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)