UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yX79Eo8hSnE05bbyzOM833y6bO3UMuyUL7DxDUWlgnM='
WHERE
key_id = 'a84121e439bd3b289b667e3780039c11e8c5e4a2c6a0691f03d88f1f69478ab3'
AND (
token = 'yX79Eo8hSnE05bbyzOM833y6bO3UMuyUL7DxDUWlgnM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)