UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4LDhWhdLb9FbKkwz9Q8V82A/HxFVISP1Yq3wSZLYaTQ=' 
WHERE 
  key_id = '9b99fb00dabc3f8e2202b8b31e4a6b7f3f3bd97a829d4fb56cad902b65dbb1ac' 
  AND (
    token = '4LDhWhdLb9FbKkwz9Q8V82A/HxFVISP1Yq3wSZLYaTQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047