UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cjil+F4mtQbmWulPuz64NzkIK6Lf6An4Ouh5j5Gqv2c='
WHERE
key_id = '1a0757d61df0cecf7191db7b00cd21ac5c63648bf00148bf165d835414870116'
AND (
token = 'cjil+F4mtQbmWulPuz64NzkIK6Lf6An4Ouh5j5Gqv2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)