UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QrEx+Uk200xyBY+4vLTp7kN2DWbzaK4PR9Qa2LRJOFw=' 
WHERE 
  key_id = '4bfc155608b14df296c785b121da502aa7f34498e7d59efece4bf7ad1600d330' 
  AND (
    token = 'QrEx+Uk200xyBY+4vLTp7kN2DWbzaK4PR9Qa2LRJOFw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033