UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uR5JRLmlWHwKPSi9q6i9XYehUiHP2Bu/ITAvNg4HdhI='
WHERE
key_id = '9762e61a166ab5ec63c0a2b244354033c687ba58040097aec64c2c058e394438'
AND (
token = 'uR5JRLmlWHwKPSi9q6i9XYehUiHP2Bu/ITAvNg4HdhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)