UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fXFYe+u8g468jngYivDc3GW2fh13ncvpIYr1f6Q8kQM='
WHERE
key_id = 'e2e14f78b99d66fe60a25bff0900e08c17aa2911506d9e9383caa56f694f10ab'
AND (
token = 'fXFYe+u8g468jngYivDc3GW2fh13ncvpIYr1f6Q8kQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)