UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rIn51iJf9ifR++RBX7zjMqmSZz5kCYwVGuwdw+gnrAY='
WHERE
key_id = '17cacc18c17e87c496da31c0cb31a2e350308c69ef7ae7f2ccdba72f2222c2f0'
AND (
token = 'rIn51iJf9ifR++RBX7zjMqmSZz5kCYwVGuwdw+gnrAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)