UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f1lMC9fnYbCAo94TrDfy6tM0oPWP4EWJD4dAeS7rCnA='
WHERE
key_id = '374449e960ae7b9f5e1c001279cbb814713c8c3560c6af60053b900edfd05c86'
AND (
token = 'f1lMC9fnYbCAo94TrDfy6tM0oPWP4EWJD4dAeS7rCnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)