UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lin5hYuYO0b24sJMWaMI0dBh6RGBZD/UQ74X70otIpo='
WHERE
key_id = '6eb77e96035a684fdb6a9da493c1c9dec084fcff6f53be464252ba1d09055543'
AND (
token = 'Lin5hYuYO0b24sJMWaMI0dBh6RGBZD/UQ74X70otIpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)