UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9m+kyq/jF8cgcQ0o7kis/1p1uRDr0X9Z0yS6pTpBMU='
WHERE
key_id = '6febba325fb03160b0847336e5e4a354722c01a5b7db297864def78c013dcba0'
AND (
token = 'L9m+kyq/jF8cgcQ0o7kis/1p1uRDr0X9Z0yS6pTpBMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)