UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0hrqRCTbA5hRtR+ZK9446wSAeWr2FCa/TfRlfSbtBkk='
WHERE
key_id = '51c857c95af46ebb9ca48fe7ff26befc1e9a33ce6745cc5b23fff3750f5afc49'
AND (
token = '0hrqRCTbA5hRtR+ZK9446wSAeWr2FCa/TfRlfSbtBkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)