UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6+g0A/zlhM2TI8rzcFnct6TfIoxB0DbD8i871c18wHA='
WHERE
key_id = '5619b91489005321d8b024e0a67858988525ce3949387635d4266fe985a7018b'
AND (
token = '6+g0A/zlhM2TI8rzcFnct6TfIoxB0DbD8i871c18wHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)