UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nlCEpvp97q2hFHDuHfeISubcVH2zFwuZzM6jOLa3FJc=' 
WHERE 
  key_id = '6180d935996acc87e5e2ff03a5c1af30d3720100f5276573f43d21529bcf8649' 
  AND (
    token = 'nlCEpvp97q2hFHDuHfeISubcVH2zFwuZzM6jOLa3FJc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034