UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UPS+Xft855bWHSUjNigncq9A9TE3FKnpaJREo0imJHE='
WHERE
key_id = '1ec4a408467112e984580c7b26f3e6f7acd0bd0b69126651e209594a4db5d0f7'
AND (
token = 'UPS+Xft855bWHSUjNigncq9A9TE3FKnpaJREo0imJHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)