UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3o1XvkhXoGl8SBlghz5K8Rl4ijJO37bvM5G1nQRlB1o='
WHERE
key_id = '92d4bc20cdeff28a57cfcd7c52ba85e15db0a34156d37f916b5eb9cdfea84bc5'
AND (
token = '3o1XvkhXoGl8SBlghz5K8Rl4ijJO37bvM5G1nQRlB1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)