UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nO79Ba37qLx9Dr4F1TAtkKNm8yvTjgiEc7xveNZyk44='
WHERE
key_id = '2be4911a263c2c2822feda59503a1fb0a8e3990ae1957ff2e801987367005c23'
AND (
token = 'nO79Ba37qLx9Dr4F1TAtkKNm8yvTjgiEc7xveNZyk44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)