UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'k95FhAtvfKWbz/jExt2jW1O7V8N6fsfeyZ+Kcpwwyh0=' 
WHERE 
  key_id = 'b33a588088b3bc201de3c91f9395371138f96fc98fa620907eb9ddb2ecfb41a1' 
  AND (
    token = 'k95FhAtvfKWbz/jExt2jW1O7V8N6fsfeyZ+Kcpwwyh0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030