UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Fz6ih5xCbeDYtcxOAZLHBx9RI59WiZGqOGWrUrwHPA='
WHERE
key_id = '695e187583ba1b48b1e49b9dac13f0ec62153ba498f3f3f1025dcbd65db0db91'
AND (
token = '9Fz6ih5xCbeDYtcxOAZLHBx9RI59WiZGqOGWrUrwHPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)