UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TQAyCmhsT6pSNnMuHyFqiM+X/OB5Xv9Tzm6ojWODv6A='
WHERE
key_id = '7bf7d3d6ecc8036e247bfcb070d8b3752ddd41328b619c52088a2f425ee8cc34'
AND (
token = 'TQAyCmhsT6pSNnMuHyFqiM+X/OB5Xv9Tzm6ojWODv6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)